/****** Object:  StoredProcedure [dbo].[usp_CmsMediaContentSelectOne]    Script Date: 20.04.2012 16:24:45 ******/
DROP PROCEDURE [dbo].[cms_sp_MediaContentSelectOne]
GO

/****** Object:  StoredProcedure [dbo].[usp_CmsMediaContentSelectOne]    Script Date: 20.04.2012 16:24:45 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[cms_sp_MediaContentSelectOne]
(
	@Id int
)
as
select [MediaContentId] as [Id]
      ,[MediaId]
      ,[SiteId]
      ,[SiteGroupId]
      ,[MetaCode]
      ,[Description]
      ,[CreatedBy]
      ,[DateCreated]
      ,[LastUpdatedBy]
      ,[DateLastUpdated]
      ,[MediaContentName]
from dbo.MediaContents
where MediaContentId = @Id



GO


